# delimit ;

/*coroster1*/

/*missing a1_pid*/;

replace a1_pid = 2 if hh_id1 == 3 & hh_id2 == 10 & a1_01 =="BANDA MATILDA";

replace a1_pid = 1 if hh_id1 == 3 & hh_id2 == 10 & a1_01 =="BANDA EVERSON";

replace a1_pid = 4 if hh_id1 == 3 & hh_id2 == 10 & a1_01 =="BANDA BRIAN";

replace a1_pid = 5 if hh_id1 == 3 & hh_id2 == 10 & a1_01 =="BANDA GRACIOUS";

replace a1_pid = 3 if hh_id1 == 3 & hh_id2 == 10 & a1_01 =="BANDA JANE";

replace a1_pid = 6 if hh_id1 == 5 & hh_id2 == 13 & a1_01 =="PHIRI LIMITED";

replace a1_pid = 4 if hh_id1 == 12 & hh_id2 == 2 & a1_01 =="PHIRI RONALD";

replace a1_pid = 3 if hh_id1 == 47 & hh_id2 == 13 & a1_01 =="SOKO NANDI";

replace a1_pid = 1 if hh_id1 == 47 & hh_id2 == 13 & a1_01 =="SOKO ELIUDE";

replace a1_pid = 2 if hh_id1 == 47 & hh_id2 == 13 & a1_01 =="NAKANYIKA GIFT";

replace a1_pid = 2 if hh_id1 == 51 & hh_id2 == 3 & a1_01 =="Kateye Mele";

replace a1_pid = 4 if hh_id1 == 51 & hh_id2 == 3 & a1_01 =="Nkhowani Mathews";

replace a1_pid = 3 if hh_id1 == 51 & hh_id2 == 3 & a1_01 =="Nkhowani Mwandu";

replace a1_pid = 5 if hh_id1 == 51 & hh_id2 == 3 & a1_01 =="Nkula Nyirenda";

replace a1_pid = 1 if hh_id1 == 51 & hh_id2 == 3 & a1_01 =="Nkhowani Samuel";

replace a1_pid = 4 if hh_id1 == 55 & hh_id2 == 8 & a1_01 =="KUMWENNDA ERICK";

replace a1_pid = 5 if hh_id1 == 55 & hh_id2 == 8 & a1_01 =="KATONGO MUSOZI GRACE";

replace a1_pid = 7 if hh_id1 == 55 & hh_id2 == 10 & a1_01 =="SIMFUKWE ISAAC";

replace a1_pid = 6 if hh_id1 == 55 & hh_id2 == 10 & a1_01 =="SIMFUKWE YELONMO";

replace a1_pid = 3 if hh_id1 == 55 & hh_id2 == 10 & a1_01 =="SIFUKWE PETER";

replace a1_pid = 5 if hh_id1 == 55 & hh_id2 == 10 & a1_01 =="SIMSUKWE ELIFE";

replace a1_pid = 4 if hh_id1 == 55 & hh_id2 == 10 & a1_01 =="NAMFUKWE LOVEESS";

replace a1_pid = 1 if hh_id1 == 55 & hh_id2 == 10 & a1_01 =="SIFUKWE FYSON";

replace a1_pid = 2 if hh_id1 == 55 & hh_id2 == 10 & a1_01 =="BOWA JUSTINA";

replace a1_pid = 1 if hh_id1 == 55 & hh_id2 == 13 & a1_01 =="MVULA LUKA";

replace a1_pid = 2 if hh_id1 == 55 & hh_id2 == 13 & a1_01 =="MVULA NELI";

replace a1_pid = 3 if hh_id1 == 55 & hh_id2 == 13 & a1_01 =="MVULA ELIZABETH";

replace a1_pid = 1 if hh_id1 == 59 & hh_id2 == 14 & a1_01 =="GOMA RHODA";

replace a1_pid = 3 if hh_id1 == 59 & hh_id2 == 14 & a1_01 =="MVULA MAUREEN";

replace a1_pid = 2 if hh_id1 == 59 & hh_id2 == 14 & a1_01 =="MVULA DANIEL";

replace a1_pid = 1 if hh_id1 == 141 & hh_id2 == 7 & a1_01 =="Chiluba Kelvin";

replace a1_pid = 2 if hh_id1 == 141 & hh_id2 == 7 & a1_01 =="Nswima Jane";

replace a1_pid = 9 if hh_id1 == 13 & hh_id2 == 11 & a1_01 =="BANDA JOE";

replace a1_pid = 4 if hh_id1 == 16 & hh_id2 == 12 & a1_01 =="BANDA JAMES";

replace a1_pid = 8 if hh_id1 == 33 & hh_id2 == 10 & a1_01 =="Phiri namayelo";

replace a1_pid = 6 if hh_id1 == 74 & hh_id2 == 8 & a1_01 =="Nyirenda Mary";

replace a1_pid = 5 if hh_id1 == 87 & hh_id2 == 2 & a1_01 =="THEWO HAZEL";

replace a1_pid = 1 if hh_id1 == 95 & hh_id2 == 3 & a1_01 =="Chirwa Whiten";

replace a1_pid = 2 if hh_id1 == 95 & hh_id2 == 3 & a1_01 =="Jere Maria";

replace a1_pid = 1 if hh_id1 == 114 & hh_id2 == 15 & a1_01 =="Lungu Alaida";

replace a1_pid = 6 if hh_id1 == 129 & hh_id2 == 3 & a1_01 =="MWELWA MANGALITA";

replace a1_pid = 4 if hh_id1 == 129 & hh_id2 == 3 & a1_01 =="CHILANDO RONALD";

replace a1_pid = 5 if hh_id1 == 129 & hh_id2 == 3 & a1_01 =="KALELA ESTHER";

replace a1_pid = 7 if hh_id1 == 129 & hh_id2 == 3 & a1_01 =="MAMBWE BONNY";

replace a1_pid = 10 if hh_id1 == 129 & hh_id2 == 3 & a1_01 =="MWEWA BONNY";

replace a1_pid = 9 if hh_id1 == 129 & hh_id2 == 3 & a1_01 =="KABASO BONNY";

replace a1_pid = 3 if hh_id1 == 129 & hh_id2 == 3 & a1_01 =="NCHIMA PURITY";

replace a1_pid = 8 if hh_id1 == 129 & hh_id2 == 3 & a1_01 =="KABO NCHIMA";

replace a1_pid = 2 if hh_id1 == 129 & hh_id2 == 3 & a1_01 =="MWEWA MMATILDAH";

replace a1_pid = 1 if hh_id1 == 129 & hh_id2 == 3 & a1_01 =="NCHIMA BONNY";

replace a1_pid = 7 if hh_id1 == 135 & hh_id2 == 7 & a1_01 =="MWAPE FAUSE";

replace a1_pid = 1 if hh_id1 == 153 & hh_id2 == 1 & a1_01 =="MILAMBO MARTINE";

replace a1_pid = 3 if hh_id1 == 153 & hh_id2 == 1 & a1_01 =="KAMBIA ADSON";

replace a1_pid = 2 if hh_id1 == 153 & hh_id2 == 1 & a1_01 =="MWANSE SAFI";

replace a1_pid = 2 if hh_id1 == 158 & hh_id2 == 6 & a1_01 =="NGONGA WILLIAM";

replace a1_pid = 4 if hh_id1 == 158 & hh_id2 == 6 & a1_01 =="CHOLA MPUNDU";

replace a1_pid = 7 if hh_id1 == 170 & hh_id2 == 5 & a1_01 =="LUSANGANI PASCALINA";

replace a1_pid = 1 if hh_id1 == 171 & hh_id2 == 4 & a1_01 =="CHIBONI YUTA";

replace a1_pid = 6 if hh_id1 == 175 & hh_id2 == 1 & a1_01 =="CHITA PROSPELINA";

replace a1_pid = 3 if hh_id1 == 181 & hh_id2 == 5 & a1_01 =="KAYULA FRANCIS";

replace a1_pid = 1 if hh_id1 == 181 & hh_id2 == 5 & a1_01 =="KAYULA BENARD";

replace a1_pid = 2 if hh_id1 == 181 & hh_id2 == 5 & a1_01 =="NGOSA MAJORY";

replace a1_pid = 6 if hh_id1 == 183 & hh_id2 == 1 & a1_01 =="CHISANGA BERNARD";

replace a1_pid = 4 if hh_id1 == 183 & hh_id2 == 1 & a1_01 =="CHISANGA RITH";

replace a1_pid = 2 if hh_id1 == 183 & hh_id2 == 1 & a1_01 =="CHISANGA ANNIE";

replace a1_pid = 3 if hh_id1 == 183 & hh_id2 == 1 & a1_01 =="KATUTA MONICA";

replace a1_pid = 5 if hh_id1 == 183 & hh_id2 == 1 & a1_01 =="CHISANGA GEORGE";

replace a1_pid = 1 if hh_id1 == 183 & hh_id2 == 1 & a1_01 =="CHISANGA JOHN";

replace a1_pid = 7 if hh_id1 == 183 & hh_id2 == 1 & a1_01 =="CHISANGA KIZITO";

replace a1_pid = 8 if hh_id1 == 183 & hh_id2 == 1 & a1_01 =="KABWE GIADYS";

replace a1_pid = 9 if hh_id1 == 183 & hh_id2 == 1 & a1_01 =="CHIBESA PETER";

replace a1_pid = 10 if hh_id1 == 183 & hh_id2 == 1 & a1_01 =="MULENGA PURITY";